SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803997 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803997 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262585,812013,377003,692163,745048,367377,616482,535698,9590,105182,396490,344570,856091,1044633,40684,162829,126408,739496,855281,443864,395728,860361,759398,977830,289663,1042001,583676,86521,770036,667682,575484,63970,320478,282345,570283,128281,983537,935831,711269,589498,952146,20821,90638,2558,992213,325501,738535,910658,261545,294715,352406,113399,1018398,764647,712140,60219,623958,105141,198120,1047583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]