SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443457 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443457 [ RunTime:0.001859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107117,535400,978974,400795,538260,163056,615490,108251,604572,245281,420719,979798,853261,621931,141580,974630,816696,365908,164568,137601,325522,1002961,459067,411855,614936,193440,380551,801908,496095,212321,572144,626626,448681,132892,66708,501667,745799,160662,695058,187115,623758,227045,1023686,361127,297228,317146,26695,695492,686393,30302,458223,205286,211689,21869,281541,1013239,292136,771288,445912,392292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]