SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002918s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400019 LIMIT 1 [ RunTime:0.000878s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400019 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613384,254510,82103,51718,179354,848678,741495,839872,572189,1029553,702494,399664,221171,351168,6960,836984,806095,56950,713928,919417,310136,983851,555579,492105,173631,784603,158641,682726,787723,649800,264219,933551,525204,731102,757762,83114,775214,668385,462102,205927,436926,805727,293735,937372,588846,275842,281669,667156,471046,596429,654236,541711,517440,983124,1028652,1012281,301735,712261,132201,999331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]