SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422513 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422513 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324803,799103,684761,1046484,768590,800601,426813,689707,57312,1004865,107243,534534,951701,250210,784134,705372,510474,59545,317800,749287,663408,897233,717331,1024513,499100,918106,37390,449781,855345,688013,260464,882525,388738,882838,240721,173071,166783,153232,411184,288037,130186,967216,693796,563,694252,290242,998395,334689,34349,647055,510004,361993,97593,46169,775180,788507,115469,245434,624153,646802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]