SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023107 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023107 [ RunTime:0.001377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472645,399702,562103,942001,783526,146387,714841,862745,128111,292540,141782,106673,802058,371712,137892,844672,1001475,492698,788033,785309,949030,768596,645030,3688,493487,373470,999966,244778,80068,937990,925919,187791,10714,715323,377428,505168,484553,266636,776680,51006,1007333,289792,120151,855329,356359,110927,514143,782902,572317,720786,233549,54689,646612,510045,254879,451702,853501,590752,1045544,852823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000825s ]