SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305098 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305098 [ RunTime:0.004361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378042,523748,945371,166766,183735,169687,841810,688614,92948,764380,500307,682701,91672,242969,436520,209242,61876,730633,696283,254416,334843,272341,205686,22518,885989,1014514,362574,895079,82053,279639,983519,212245,272348,753839,937131,476276,193499,170229,253858,311318,338975,151116,428034,647971,1022917,147798,278387,147257,24556,222473,506747,799587,415074,46462,644984,630034,896516,312984,158322,129198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]