SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171513 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171513 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938108,863804,413196,77126,530431,1013484,933646,824269,820211,920888,560738,212727,469636,790950,713474,307442,858148,437181,904530,741230,668895,678156,444841,774489,536084,791539,957932,16996,448219,341199,872335,330144,163865,345214,530183,57878,71217,85377,805875,413978,499099,775963,1009394,726052,729717,823767,491384,207292,681492,139889,57632,985294,728022,462131,773102,36811,106766,295386,115852,909964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]