SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014917 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014917 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194150,499495,483001,153780,631369,1029752,148252,561668,859438,470968,645969,606859,253837,672538,255279,827127,387346,938596,204256,799567,1016608,401670,687464,960316,608641,229592,373915,370962,848341,158449,730814,129686,126324,553455,184335,250885,738437,58031,332915,886689,171077,976880,210483,356978,794109,795220,138472,484165,492607,1045721,718308,820724,440052,436189,798131,713756,959631,930749,488057,491284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]