SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50019 LIMIT 1 [ RunTime:0.001533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50019 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393918,378709,103067,410291,536161,382244,367372,1029180,718798,366346,238341,834013,935612,882887,662007,957779,573689,730948,491255,545315,201276,196830,820943,747184,352111,721181,452235,37958,503700,261848,449815,468018,892075,289294,897517,872635,50379,377956,328424,18388,407202,170890,439651,22829,897770,46382,597308,999082,433790,687699,603416,930185,32931,809237,567829,106147,715308,241668,836472,700036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]