SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001892s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445246 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445246 [ RunTime:0.002270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630345,225858,436762,773717,736582,779033,957749,302839,120114,419576,643601,772641,566606,885133,281692,726948,521938,144462,948111,42669,428667,391306,81608,188040,211620,862556,519275,394058,795452,252216,910832,1000984,534482,469643,235303,813909,603945,224312,686964,337381,764210,393167,882132,14461,849943,557824,136897,609145,913456,10892,535220,80165,581695,948755,374846,368645,779547,246426,103479,322983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]