SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517701 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517701 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515132,525393,782149,38226,396887,440406,1015987,337247,565575,359070,115601,325185,88368,812264,275302,1002243,147070,994131,107114,536312,437312,706210,995590,425071,534446,470720,466172,810927,104825,470408,449822,159871,929068,117646,809013,888650,671600,312528,133932,112280,404703,173759,396071,478729,310041,835467,488395,671171,484113,769464,967447,977199,293748,250771,823520,721490,13930,515621,995784,461532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]