SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51072 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51072 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98001,869812,157044,699043,961800,834299,561785,514274,354833,520249,228194,141630,392626,16095,400102,190523,177848,612162,225133,57457,8512,340575,246651,1029700,187299,865886,370397,1022652,925322,383120,1041126,14,753673,301304,447258,492817,737219,781984,82270,75998,533801,1033030,767792,594094,639976,870127,1003095,247395,520909,425880,279206,153014,682623,324647,440176,341240,601054,144874,40625,15356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]