SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001974s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017613 LIMIT 1 [ RunTime:0.002356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017613 [ RunTime:0.003586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711348,403040,808196,26657,1011964,451678,146346,659727,716340,959281,637971,439238,375474,237962,830791,762852,1003156,569008,885416,227112,13557,848613,63188,366301,51931,277384,1024570,863934,559331,684356,534493,902505,152086,459282,978746,121301,135661,66898,884741,451386,38090,30247,756538,866218,1030369,567567,911428,163019,721947,972919,932910,968325,313629,380667,101091,415226,833293,607075,411893,924052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003434s ]