SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507620 LIMIT 1 [ RunTime:0.000678s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507620 [ RunTime:0.001265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7496,54770,468965,282801,177602,1028472,648153,968834,551958,901330,142879,393569,460354,854188,198567,316039,227373,737993,849867,1011465,422339,65371,966046,439845,667008,1034483,74908,174141,53363,412393,540392,262108,780690,298364,797904,262862,870905,913541,323096,643105,457458,898246,754232,1039027,377461,279750,166202,30399,674306,952720,55585,195619,124787,439535,1015345,308173,705563,15202,74130,1027168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]