SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50961 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50961 [ RunTime:0.002493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962394,722312,593308,305292,388594,746620,994662,1047911,805492,274821,912127,399480,141336,459665,356625,348702,745158,75954,506651,675611,235657,443536,712443,960412,202745,446888,333552,649573,1013930,129779,894358,667,492871,218959,877399,568592,156964,997910,265741,868042,290845,214587,531578,502301,271300,719235,542485,327138,402125,991576,221730,67313,593112,46007,357246,369689,902364,956402,914084,707569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]