SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504884 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504884 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257951,181690,300486,906422,877224,776929,982614,581290,38268,974192,529198,994315,27525,376887,531575,767539,735021,654710,50151,701830,133585,775331,763830,839521,658627,144503,248797,1020075,108659,341993,543595,249003,225791,391286,919241,676813,897821,551291,170894,276589,280373,434300,103852,1032582,731215,1027656,802079,815162,267822,42007,745306,1029418,974128,398814,496090,42086,527797,523369,872657,962689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]