SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001621s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449211 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449211 [ RunTime:0.004579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320892,636281,88684,757014,163395,302393,448387,101774,430239,588251,35178,831406,606875,376485,110910,73684,152684,681812,674063,300320,830197,945425,254203,315200,3905,650532,7835,176195,194323,726399,705096,832129,387210,308617,839626,303516,332670,572714,913067,18012,565885,925036,559828,714061,111951,987401,72854,189265,386573,46577,520640,1467,585371,1014907,516244,1012964,175239,222995,928619,967819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]