SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528992 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528992 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407194,364456,875416,441594,1024391,389997,281342,532120,453741,681951,754792,996854,8796,471567,18829,252191,462504,179823,902811,977250,575133,666077,928945,207495,870194,157787,1283,152123,240731,730463,783186,356877,955675,818294,776024,895362,199698,684494,39812,211046,231598,680489,201450,1048824,412203,634987,541303,689447,679393,88855,445370,170813,51634,1037355,1048274,828359,763511,196646,1007761,439514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001641s ]