SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280740 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280740 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775847,930096,1041562,819919,356540,1023020,302454,146870,1030422,768513,848181,113612,251930,805486,658123,344716,911487,196872,1041719,403614,609742,346998,831569,370965,849721,19805,450365,517362,454195,33357,923259,568625,573877,860841,962187,499440,734475,962343,718017,409378,452647,747041,607351,210040,599328,511595,146674,696860,661157,730566,917809,782673,157492,359745,346490,293869,149719,612366,1024832,430055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]