SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814670 LIMIT 1 [ RunTime:0.001280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814670 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406280,1032595,906726,517971,22897,788551,1016269,102438,114459,191018,1001854,562865,152013,752420,933385,684502,345080,686033,961091,1024668,894488,958991,267279,875614,41176,526745,581556,382615,912010,651397,572933,383405,276687,999111,134479,263452,321390,162207,165075,493458,851792,2365,703103,955470,209353,602961,583143,870548,419994,63100,910665,661638,345193,573216,667027,719525,357653,561057,927213,574693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.028047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002967s ]