SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982797 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982797 [ RunTime:0.002524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439104,847763,395170,507492,201548,630160,455203,612017,696170,355231,409864,591998,152817,312666,945585,973339,542424,829131,334959,151635,708482,307878,705665,114012,3278,37643,196632,472338,327351,323232,261939,104549,227366,437871,146108,475501,564310,1018125,174048,147019,647599,650771,744152,954190,339854,959090,264437,570185,799549,839961,38407,226215,705779,493931,93592,698640,902595,294096,247097,548751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]