SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474993 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474993 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48203,223045,1027782,770131,862275,469774,146993,570217,717680,982366,17609,231729,840937,491489,1009792,665703,890230,556308,681141,549544,220652,198118,785673,524775,16674,814549,665462,22228,549288,231575,700110,978257,373909,737343,53116,234746,415208,42956,426005,175228,95661,1025271,307157,381301,351515,49118,664512,782394,971840,614336,817033,456929,749910,715317,115501,203965,105597,505549,1030441,216356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]