SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41692 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41692 [ RunTime:0.002244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002144,693452,301953,623231,58820,583819,328282,800710,416940,86589,422083,868381,297100,799951,856694,104033,300436,66253,281019,405454,795733,609967,458097,260198,499698,663667,414811,770737,906341,133115,256533,93323,371534,185504,384545,59665,1035328,869829,886680,215958,164683,354795,397783,623648,959292,690731,237978,947144,228681,78953,202899,847677,417313,705989,709693,1027922,355535,266930,667285,228002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]