SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001644s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391493 LIMIT 1 [ RunTime:0.000511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391493 [ RunTime:0.003667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602256,105457,293297,181559,861836,886153,828816,537847,956075,965884,584672,253631,858764,561647,637868,453953,956677,53896,714372,436887,280154,536895,740729,38496,741889,86355,305395,703205,102710,304604,486927,57077,680497,902648,862999,381574,129932,440747,332542,964524,644099,608435,600973,350667,404818,27049,99938,665129,529454,827236,855701,356895,214144,721489,591382,781001,506935,255105,341875,511565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001870s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]