SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436538 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436538 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993325,156091,287531,102325,18638,561052,293881,767044,381747,946098,794128,995961,412281,242523,779395,392597,682395,12964,145357,664285,1040732,829085,839541,819385,86825,439505,215943,628383,1000370,1027749,1033711,745443,557447,89606,933564,433427,28701,326377,67039,417838,699103,875996,1043995,781788,251102,72835,800700,263637,249830,688212,917498,79525,352649,727465,731834,332462,623394,484142,60011,388529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]