SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54384 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54384 [ RunTime:0.002069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490909,50209,298474,5030,156759,400104,293052,330951,903718,651399,667850,612851,214644,944569,92839,1046856,878065,526287,210727,104800,725859,840138,1027223,759239,952956,389700,416716,985332,56416,489714,531244,839468,586429,84506,997484,322019,967131,752582,318950,886599,379926,988482,424526,204548,556465,129114,837346,460390,863501,769652,871815,879678,536822,283748,353540,868818,579712,786375,418416,156073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]