SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543064 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543064 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50688,724591,194320,73666,174309,189626,72936,450305,371072,975036,40347,817288,348133,918521,522886,732669,688714,319493,1035791,656700,84432,716884,495862,859580,353503,822883,139889,382679,63597,886315,805029,853341,388747,671145,967654,510803,827866,399678,307870,618934,134491,637200,929873,1035970,806690,748953,392354,742849,951869,523724,1036341,372509,434541,333009,254664,292928,412357,203042,293261,117514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]