SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514578 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514578 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581264,301600,1039792,31384,198802,388306,261129,947037,349436,993244,449855,953291,764639,975484,273577,875104,697106,420175,105430,199568,274809,592475,688349,335005,155459,242244,479795,320635,781910,644856,305579,940701,511101,156937,883173,703003,151287,96698,343053,730794,463367,29697,918087,201716,99442,736443,725650,213288,103916,713448,536072,439676,597325,151072,90087,691150,217495,996697,186627,745275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001851s ]