SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596623 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596623 [ RunTime:0.003244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027468,669134,901342,298741,603177,313958,771936,551143,408632,243939,308007,680791,217724,334180,174309,937653,924606,594295,746303,515305,910857,1017533,46315,62980,560097,958932,672963,703118,760119,372021,216690,187156,669620,871274,1010387,457520,403619,436606,57971,1039167,395518,742195,310389,262546,841537,682819,31463,1013970,756800,977703,1017380,741286,802625,648773,298555,99687,927529,101443,728794,622182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000874s ]