SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045561 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045561 [ RunTime:0.002540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315168,825373,744631,233277,711090,712891,994664,927611,102613,478775,59689,566143,112842,66309,1011565,41398,447693,535316,1008968,54049,504745,166422,662474,195815,725683,878370,68620,235240,436425,910347,920110,98352,112263,86543,646860,576089,413487,744556,113581,102823,711360,615141,234638,365119,970883,1048362,886996,485852,19906,558542,961072,712978,420402,457460,893527,59547,1023064,790201,900099,831848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]