SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438099 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438099 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006125,567168,668440,408194,405015,845631,401288,530928,802231,378145,786098,959120,49465,113868,204161,109711,570142,1015442,886019,272235,115667,795640,760333,45070,311700,516704,813184,719996,990906,666991,235599,206061,290169,646600,289753,508185,980955,87646,345809,995322,37039,776454,681588,703758,1000467,37180,43855,113568,417485,978713,904476,303990,791683,413489,106015,753419,1019963,1041182,598880,56374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]