SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503956 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503956 [ RunTime:0.004688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508602,120836,871501,4682,184224,661406,841947,386298,219932,1013676,183332,99833,798403,522480,383875,819362,128224,799452,322332,625312,338242,27174,76928,13157,185934,502174,1040537,731394,414916,942539,514925,316568,179244,584598,494602,214525,228745,255408,315503,375018,655833,1029868,199222,403433,129667,696169,901165,826192,489421,521166,460300,711668,900460,848194,66975,1027362,966105,10194,381849,634987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001295s ]