SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028175 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028175 [ RunTime:0.002074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346050,304930,839228,340175,107298,924837,179066,935484,346157,97854,486054,466426,13600,154131,951049,452836,860978,846812,186802,1022557,271638,49471,673136,147033,315380,429824,857222,280228,928044,763715,1026199,379434,345067,997204,271885,801380,156906,688965,376254,822415,851012,10371,400482,191766,518249,657811,341510,619007,865737,1024615,496286,78224,367280,519349,501687,754494,294856,698264,124220,719441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]