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` = 530515 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530515 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181894,185228,495628,621488,792776,393311,620618,715235,833981,54110,56328,594359,211318,50689,643998,22483,235317,563959,698286,663688,666708,1037148,58155,552070,89892,430282,386559,236460,485926,555243,4591,1007450,563049,219935,678334,172836,28261,723283,39139,975100,669356,307436,749886,27476,810102,803567,832351,873770,1041497,138389,857870,340180,134416,819229,355223,926064,618134,27189,727209,482041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]