SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 992583 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 992583 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183702,760543,593330,42617,1030356,891306,93321,166715,879372,754634,554785,641518,372694,708590,633891,613725,114892,867871,234387,627825,388421,1043321,462369,361122,719116,504535,658219,213755,902785,866530,320136,371728,500518,729843,1009181,711433,771696,228845,127322,437812,508424,668270,323791,203120,1044850,693751,319873,669498,316110,555428,72611,394470,484396,167627,781722,168491,272852,998006,842437,928455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 992583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 992583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]