SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445286 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445286 [ RunTime:0.003503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952502,710868,320641,720045,96495,170134,737440,115116,386109,71673,145370,1028215,846608,801529,173094,522621,567738,628102,85567,334161,219915,963416,997170,955068,892197,160671,167150,505879,813957,344893,90675,851514,121352,137147,309764,19842,1001610,324189,720631,660009,913175,169597,733141,524351,1035547,146843,989832,463015,394311,1036687,967221,217100,39763,250610,976319,644806,1026380,794018,1008389,135830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445286 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445286 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]