SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538640 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538640 [ RunTime:0.004605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102901,45830,224099,889411,682395,280545,142068,664977,79307,789328,578213,288746,935197,647482,663048,871469,543409,661748,976188,542129,901742,897946,167086,846682,362518,352400,895143,632415,198785,720857,2805,340752,487792,186312,519592,142134,176369,561911,556229,596265,724409,304696,456283,374319,477107,72957,837727,350191,831442,667421,840585,382831,764936,729816,898484,30732,482142,993776,165910,945755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]