SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578853 LIMIT 1 [ RunTime:0.000272s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578853 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809783,312265,906010,636796,497409,83487,511898,360891,113552,1006535,827380,1036900,909442,696826,37733,227803,536263,1045868,575519,267980,909474,714689,587482,239330,403933,773412,262199,575586,151818,842768,339213,206363,3328,939088,1033304,761552,884456,827131,674425,849275,705290,1033971,201423,739551,22789,170137,581177,808965,267727,201603,509291,811826,107753,161067,625546,72330,1029093,1047810,116908,167656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000971s ]