SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040257 LIMIT 1 [ RunTime:0.001304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040257 [ RunTime:0.006690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583343,198583,127007,477018,652095,500560,917571,915083,709284,406697,970853,334705,959893,345932,905728,459766,728884,766524,961213,264948,899358,1997,967829,421547,504109,1010981,675696,568459,543145,129999,483699,996355,174142,169737,350700,296619,938477,590414,140169,993887,306393,863451,653028,729276,65472,415916,401640,876918,600454,1046944,993309,570035,220810,117876,332420,530239,307117,68580,208167,159744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040257 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040257 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]