SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584686 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584686 [ RunTime:0.002180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194910,234610,765767,873463,648509,266895,456050,867031,40533,70118,824985,113945,564993,348875,982623,177994,100040,699567,12882,37694,78783,143681,551688,481867,369525,968439,677636,416318,391092,806893,37843,342248,209008,961367,657430,256131,438792,433838,426296,245085,925326,225399,510973,229892,76910,116104,131677,735515,849934,925433,535644,600876,985268,375141,155995,702049,621429,624356,827681,56015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004333s ]