SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477891 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477891 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (795698,638095,372002,437684,658033,114791,445608,425302,629578,601005,872395,1008566,841873,818859,111935,688742,547745,846482,383274,521030,197929,397140,286738,920606,87673,199349,467229,862461,414937,28223,373268,117658,289768,267162,457280,474686,71324,1534,293009,1027340,870402,139430,325389,430528,981073,121824,104204,266808,12373,391108,693190,488459,745497,1028873,926207,595766,16792,710192,763349,993924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]