SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001914s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28117 LIMIT 1 [ RunTime:0.000632s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28117 [ RunTime:0.007361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113956,994935,716102,905561,27791,1014490,604224,836156,3914,738178,780403,385324,929247,732840,644289,523721,63678,998368,1020273,675780,999213,82345,479249,182950,67556,303749,298484,211566,566177,624736,782730,138533,42497,474913,326322,750615,888967,567320,198165,711396,109447,166355,129762,648519,275356,559085,995799,133221,1001100,938951,710276,942343,665001,812046,129133,1021310,320640,11432,632350,407541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]