SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 941596 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 941596 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490649,145824,961978,815524,75680,514357,474188,476054,486817,987480,1023424,791534,810468,603435,111336,933511,94742,853970,427970,693007,80432,758419,101404,607502,583826,100224,681595,1032489,710862,204834,914798,18310,507195,160594,749290,777747,804700,784558,648685,900809,622576,12491,414272,187450,453741,686257,461236,599121,49001,254736,462188,727165,933660,166989,15998,528528,497686,814696,265083,727352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001899s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 941596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 941596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002862s ]