SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488021 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488021 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143999,407799,56039,26198,1023166,374223,993330,711857,123460,774696,505424,828503,826102,986512,487399,195068,221748,675980,41309,761409,696411,886191,613802,222262,1026238,1040221,979565,285879,131291,103210,871513,83309,1047996,469900,1029255,235058,551480,979746,74250,191718,647492,516821,146156,321397,730361,278141,265354,585314,373810,52445,452116,942379,405781,936125,422017,166278,59931,769140,740484,948016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]