SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483023 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483023 [ RunTime:0.003047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040392,18665,691274,375846,235741,676265,19070,527009,527601,121062,1003729,579156,189584,496619,451876,374331,266283,22695,401488,564648,584695,496345,1026251,875999,649724,27293,511865,319582,580855,704074,513898,720738,1016101,965150,798760,1003856,572595,373753,305429,563393,682163,919293,364488,526380,883302,404947,29751,777520,168327,49445,130197,955629,269242,694781,419507,663490,573060,353152,1041236,307356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]