SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008243 LIMIT 1 [ RunTime:0.003694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008243 [ RunTime:0.002189s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242950,691839,548592,214169,213937,155637,189287,693363,543475,561885,457666,410345,151658,225838,1022568,831306,617887,411386,968494,966869,178985,286966,350073,522200,439096,827496,117880,200169,886942,692785,707206,359122,145982,789805,106628,442922,799271,979251,961226,1002675,37179,685091,152777,972600,380898,668419,368704,895871,560585,528513,992527,824454,752402,555317,534543,583700,655756,270838,140499,164454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]