SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531325 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531325 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631035,273072,504702,661598,846242,804238,511876,677564,100867,35536,644191,532947,841945,30759,107475,130267,228537,455963,928950,877383,613128,51153,59046,1018000,1033887,339167,579453,874612,628813,676760,163702,559257,429345,628343,964029,113558,18016,774363,529910,356447,78283,658855,361489,285047,79022,30484,943434,210011,128809,894641,899568,101127,52123,924471,689863,1034210,342037,740897,71972,94469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531325 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531325 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000861s ]