SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48114 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48114 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227046,830959,679506,98871,201383,749227,789410,639845,319354,731760,191407,471356,567416,964631,697530,678499,263966,63014,1036036,855737,475776,354692,38157,637658,426826,86564,762635,487328,106554,632287,235914,893719,47890,946317,263025,962074,908847,239418,379251,914335,635190,900037,444578,405825,808750,1028111,797406,625546,368300,20185,124112,950184,564423,369552,281147,436916,174886,120599,225424,924840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002232s ]