SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571291 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571291 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964149,967255,701779,608559,46657,1003673,677684,1031290,644381,598998,488661,429292,919541,658978,865770,1028145,152866,656110,224431,358961,896106,224800,1041863,1043531,202521,241138,765263,437993,14371,396100,870661,1033184,388978,780777,813920,299333,840700,512546,706506,150111,349538,493410,428195,856944,325320,269360,461792,772836,990191,41589,109262,588438,227483,814521,448326,560446,521606,417103,685425,595761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]