SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001897s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460032 LIMIT 1 [ RunTime:0.000668s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460032 [ RunTime:0.003000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402029,937519,441083,604513,624033,6107,964171,616985,1041988,558347,268452,1016162,779985,489487,949449,499278,814045,220714,482762,704321,91633,49159,1006489,341896,263743,430606,247441,805615,355844,992542,892371,542789,671119,318960,290647,222801,472137,1001469,237660,12867,107885,169335,223842,659357,433094,752579,716558,884528,652105,429966,710098,708960,64428,231783,431341,2148,79956,700242,824870,453157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]