SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001946s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022883 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022883 [ RunTime:0.002370s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415808,2234,179645,78027,722591,685149,490608,211984,104986,512327,1045756,599718,962340,745509,844923,393564,677017,405919,524797,456240,88429,1008935,551040,872030,157117,37068,559411,267447,605846,246448,54207,472660,378896,1040053,784065,342450,137277,685008,769730,61253,576489,279009,395091,133027,233524,364552,1034305,871077,323872,538476,630430,386694,225122,989448,950133,259309,421386,789559,649999,157504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]