SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546231 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546231 [ RunTime:0.002086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499249,342041,468589,63969,140278,268562,439516,565610,747044,725400,368220,652055,1040252,815304,553239,853033,686649,111124,560365,302827,128609,131954,789428,491017,402790,946701,40028,751352,487855,275467,1046470,238544,482913,944907,67238,899927,410970,408423,869623,314068,301859,910676,616342,69166,224019,96777,688747,362433,778236,373269,564666,147798,124621,659431,1041200,898141,834943,17088,223582,896369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000704s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]