SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535321 LIMIT 1 [ RunTime:0.001752s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535321 [ RunTime:0.005247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103388,424247,64625,549494,666032,363280,780491,781776,796744,325735,572086,896084,249594,716014,31061,933963,554541,600791,95781,793586,804553,484108,353387,896277,631586,310273,590569,910403,124371,102175,355417,762084,473029,892080,248972,373715,870426,1019198,43092,527868,286598,181110,558044,192575,740652,144051,493047,592136,601451,69276,890108,671459,733115,486838,211951,50963,705584,920655,822835,716107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]