SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586817 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586817 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984190,694183,934907,329782,362503,442592,769933,770553,834236,2033,442734,802875,1047682,960784,56528,531816,843449,740482,796502,200073,89792,357026,124612,113491,940932,886886,449694,685322,1044768,135941,84464,847982,531551,605015,357067,240679,743301,200147,686972,278489,101746,729076,575156,19434,877231,347316,1036757,737159,542123,447808,443092,460658,727705,781371,447274,1006182,504045,987115,480911,752880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]