SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486036 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486036 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547078,107918,965281,291493,534805,832885,662041,148802,785052,771618,825463,462849,157916,251127,56787,22688,506108,710644,94945,694350,706972,411573,112442,866268,793606,346153,336617,125069,191325,434202,251497,514470,856810,103470,471794,613634,1010077,196236,431749,318453,733970,468387,527624,959751,1031310,319382,145304,465503,544034,758873,791134,460683,389228,157187,28760,11806,898687,777732,805784,745532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]