SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518328 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518328 [ RunTime:0.002496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815803,417536,759104,802531,826699,359349,760979,403762,261014,474799,274210,679730,708122,367144,366838,312880,582006,113785,679015,583826,799504,695824,675363,785716,130017,220553,192253,498541,192837,569639,924157,544469,182352,932581,445438,582423,280261,595296,961715,420623,698494,449110,787215,923737,9614,991681,773828,634459,297170,977368,52513,890003,939065,929348,629151,725036,385001,613794,68737,100048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]