SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 84201 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 84201 [ RunTime:0.003275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343790,382610,563753,915460,1003758,531039,187730,801813,732213,305310,31106,668879,244726,590032,435483,55618,969474,111425,257320,608700,522063,199762,80782,806266,510417,82024,115310,704569,256247,35757,970675,383406,730677,231075,783761,907080,28568,479920,941526,940923,884386,794191,745521,373693,386817,1041862,896979,937108,369399,865125,156467,610171,659188,705527,879045,671150,223758,508624,927675,85381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 84201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 84201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]