SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 921393 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 921393 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044000,30596,399630,406200,674815,559200,840187,990370,892341,618068,823686,682105,396897,703965,410024,484465,608388,268659,706118,658130,801787,884629,585842,386366,539177,89527,923580,589463,605912,541091,846055,876116,1019056,63681,875198,340552,735729,677663,151527,656287,979373,441545,496862,600656,971608,969880,5632,375017,93954,900577,236540,139554,267640,163412,787525,446557,492515,293428,939297,157241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 921393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 921393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]