SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431101 LIMIT 1 [ RunTime:0.001244s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431101 [ RunTime:0.003162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602154,145003,118136,827665,226106,261634,914009,881254,1014040,162568,426358,621584,353824,918233,239530,644144,319130,770389,775241,721049,1039844,500969,247039,278993,183146,969688,340533,516289,371817,609312,560984,907799,573509,826657,508569,901717,3600,905997,302484,175320,871994,181951,211980,129499,649921,681588,702858,767997,893130,451346,322934,731062,808092,227659,299371,760057,258318,507527,410489,640409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002300s ]