SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541596 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541596 [ RunTime:0.001535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502303,125066,923264,1040586,68157,881933,838276,53015,291282,838569,257199,203662,336229,32301,655134,548634,713215,529758,273547,877886,735153,617728,875386,853836,508982,338145,850003,254518,864044,288101,167733,567901,640745,744353,734322,803610,579690,67447,39036,318345,915254,512856,128273,331325,66760,80610,186292,12672,222447,371047,31766,509318,679172,656311,218639,178552,884557,561540,524245,47697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]