SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282847 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282847 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973202,1025320,653278,113960,250229,240301,670632,434023,488154,726449,61635,426183,417294,523255,304985,898734,462776,895330,1032915,704816,913116,1033376,366829,814993,18571,244780,249241,498238,231664,408619,511828,957023,364777,380223,419860,102357,86595,32320,472235,543066,128210,437046,449870,663899,44830,993870,1004972,170705,287044,280175,730678,97815,216216,393406,205298,44106,558253,418469,90359,17961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]