SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003370 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003370 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523862,167106,115163,1002946,800204,891593,830355,54719,591909,214807,498810,1047916,855840,769154,358263,201003,179521,197799,975356,500592,829067,609006,145573,123257,439920,23361,467814,447282,704544,801366,1033253,397537,911583,782797,617321,797464,741760,184405,435012,982158,723720,360866,812493,183900,1023452,766611,748423,1014408,407183,871540,15215,876302,450772,260762,126674,728970,928574,973167,917554,952106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]