SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291813 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291813 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022592,115877,473145,228207,670647,143081,827719,440584,286430,109857,1048219,768659,373107,14621,1003339,971035,318655,547351,222224,634642,326058,149987,1023164,392419,697241,1028617,775298,192660,553662,340727,703882,573655,1027187,329936,281970,778437,747254,22611,725412,414347,881792,749963,460814,8891,299052,907438,408687,770055,811216,137740,506305,768036,496166,1025843,846611,566919,452567,209031,538661,17055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001234s ]