SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419900 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419900 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566428,535833,590983,1000639,962054,75451,281353,978510,662015,835702,100845,267664,463658,1023277,528838,706315,328661,811712,274680,771893,580775,888577,441173,355677,140021,460012,255768,288815,646947,627084,623957,151930,11883,124974,10667,466236,638294,749210,696471,339373,1035483,67845,848794,275040,401634,201293,4373,235284,111063,851029,87228,123385,292474,146959,1022898,841590,87801,734984,987130,897666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]