SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561580 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561580 [ RunTime:0.002295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726136,451028,124296,1039145,342552,742424,259857,293857,50841,362967,632653,268454,378821,1002484,18038,851585,547859,192074,98417,431027,943547,692380,437987,189301,705728,184772,796972,344059,345410,400291,718440,925149,1009842,609159,527328,632119,1041082,386254,241185,528979,456100,1036297,346091,825454,59947,338273,107175,4803,1039342,420704,195000,122660,810970,112984,117070,587414,559262,695281,378219,85536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]