SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020630 LIMIT 1 [ RunTime:0.001972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020630 [ RunTime:0.013039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656853,493228,255556,893377,461748,364706,95724,292875,499613,466867,297212,487813,385861,921217,355554,978193,761078,394668,541456,549433,910822,491068,128030,912394,170850,2171,163406,233883,514932,164800,40338,154514,658299,115469,496674,395645,1023673,970456,776878,431815,246707,394029,341266,217145,738157,760049,508940,831186,996976,243335,581481,696364,259345,158968,603708,470740,923279,886737,954236,410797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003468s ]