SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543322 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543322 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517546,87860,15373,276211,159804,640746,650139,289957,57385,155767,152776,902466,756135,264326,485519,517099,555161,695388,254946,431313,655875,450662,593018,176947,457600,939048,913478,940451,758465,188747,109445,389352,991015,701144,236267,886950,175109,296844,809737,52790,555992,761160,744066,577555,571913,733734,864912,27317,947822,489749,753466,829322,573548,129442,792616,247334,400497,1023838,234315,899680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000809s ]