SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502849 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502849 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349604,609696,658148,665748,285519,945782,988957,537424,151834,1024858,205800,274975,376789,380237,195778,551998,1002313,536725,219700,128401,734879,737728,947303,14634,213096,589096,705155,389819,448910,304109,539115,111041,37549,14923,293178,62810,591769,250378,830875,962925,454830,741974,578232,187698,250898,528460,441768,759127,42273,919986,942872,1006881,1030523,957213,992309,674142,119459,383759,481637,452427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502849 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502849 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003278s ]