SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447435 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447435 [ RunTime:0.002549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137874,1012088,712469,331093,130597,1047251,90270,394742,483542,476828,186253,225386,141416,27862,297138,744871,967251,237954,220795,574089,898426,547737,1010936,471514,175100,903324,770128,625934,146038,729650,731444,46395,918171,970336,707602,334351,233942,189214,181930,78749,242304,159063,139722,286923,437791,496923,950062,336763,581931,401076,555265,129477,389985,631148,1040391,509201,554105,868373,552487,406659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]