SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515501 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515501 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032965,3026,919511,367390,311314,207589,346762,864363,760768,9709,640433,222279,878993,734559,639442,912355,396613,968420,457670,268261,108480,193633,828216,794529,1020465,93778,434379,258647,723237,207759,484594,195800,256543,419039,687995,573877,1031823,732052,510165,777294,521754,367134,454155,546534,924162,203135,1028388,709568,135539,338548,907587,202447,441801,191080,45503,343155,127956,620831,153566,520778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]