SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425001 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425001 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570071,153659,383567,676079,706525,668387,727351,261150,1040987,64437,554607,674632,868782,465889,692452,399559,608784,5361,1036170,6994,195293,122231,865299,394700,1037078,925278,911671,69272,529601,417851,242115,519837,812853,278377,461659,496199,921317,117587,137726,83400,1028776,333827,280546,723647,299996,711260,483756,19069,426235,682509,812882,165574,115261,291423,954670,758340,443815,488646,100861,340377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]