SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101151 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101151 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173638,721116,598166,994637,186825,935418,998888,735466,426241,730803,31186,832488,80954,460500,835380,516602,149885,644288,993160,837574,84108,1013013,355006,137051,49620,639878,662866,86265,925346,593988,873675,465216,647041,118603,223791,292860,399512,989682,758611,974327,372213,697414,693113,881875,856679,540793,353708,801313,975922,608591,840655,769501,18820,969878,961063,512097,726463,525575,309525,842382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001865s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]